Pandas Profiling Report

Dataset statistics

Number of variables	8
Number of observations	807
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	156
Duplicate rows (%)	19.3%
Total size in memory	50.6 KiB
Average record size in memory	64.2 B

Variable types

Numeric	8

Alerts

Dataset has 156 (19.3%) duplicate rows	Duplicates
`Battery_Power` is highly overall correlated with `Mobile_Size` and 2 other fields	High correlation
`Mobile_Size` is highly overall correlated with `Battery_Power` and 3 other fields	High correlation
`Price` is highly overall correlated with `Battery_Power` and 3 other fields	High correlation
`ROM` is highly overall correlated with `Mobile_Size` and 1 other fields	High correlation
`Ratings` is highly overall correlated with `Battery_Power` and 2 other fields	High correlation

Reproduction

Analysis started	2024-12-11 11:11:21.580017
Analysis finished	2024-12-11 11:11:24.400166
Duration	2.82 seconds
Software version	ydata-profiling vv4.12.1
Download configuration	config.json

Ratings
Real number (ℝ)

High correlation

Distinct	20
Distinct (%)	2.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.1126394

Minimum	2.8
Maximum	4.8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.4 KiB

Quantile statistics

Minimum	2.8
5-th percentile	3.5
Q1	3.9
median	4.1
Q3	4.4
95-th percentile	4.6
Maximum	4.8
Range	2
Interquartile range (IQR)	0.5

Descriptive statistics

Standard deviation	0.36783027
Coefficient of variation (CV)	0.089438978
Kurtosis	-0.28282511
Mean	4.1126394
Median Absolute Deviation (MAD)	0.3
Skewness	-0.55938623
Sum	3318.9
Variance	0.1352991
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
4.5	135	16.7%
4.1	96	11.9%
4.4	91	11.3%
3.9	72	8.9%
4.3	66	8.2%
3.8	61	7.6%
4.2	55	6.8%
4	40	5.0%
3.7	36	4.5%
3.6	33	4.1%
Other values (10)	122	15.1%

Value	Count	Frequency (%)
2.8	2	0.2%
3	4	0.5%
3.1	1	0.1%
3.2	3	0.4%
3.3	2	0.2%
3.4	27	3.3%
3.5	32	4.0%
3.6	33	4.1%
3.7	36	4.5%
3.8	61	7.6%

Value	Count	Frequency (%)
4.8	1	0.1%
4.7	25	3.1%
4.6	25	3.1%
4.5	135	16.7%
4.4	91	11.3%
4.3	66	8.2%
4.2	55	6.8%
4.1	96	11.9%
4	40	5.0%
3.9	72	8.9%

RAM
Real number (ℝ)

Distinct	10
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.9417596

Minimum	0
Maximum	12
Zeros	2
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	6.4 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	6
median	6
Q3	6
95-th percentile	8
Maximum	12
Range	12
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.0563593
Coefficient of variation (CV)	0.34608592
Kurtosis	1.5350452
Mean	5.9417596
Median Absolute Deviation (MAD)	0
Skewness	0.26642688
Sum	4795
Variance	4.2286138
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
6	421	52.2%
8	153	19.0%
4	113	14.0%
3	39	4.8%
12	27	3.3%
2	21	2.6%
1	20	2.5%
10	7	0.9%
5	4	0.5%
0	2	0.2%

Value	Count	Frequency (%)
0	2	0.2%
1	20	2.5%
2	21	2.6%
3	39	4.8%
4	113	14.0%
5	4	0.5%
6	421	52.2%
8	153	19.0%
10	7	0.9%
12	27	3.3%

Value	Count	Frequency (%)
12	27	3.3%
10	7	0.9%
8	153	19.0%
6	421	52.2%
5	4	0.5%
4	113	14.0%
3	39	4.8%
2	21	2.6%
1	20	2.5%
0	2	0.2%

ROM
Real number (ℝ)

High correlation

Distinct	20
Distinct (%)	2.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.390335

Minimum	2
Maximum	256
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.4 KiB

Quantile statistics

Minimum	2
5-th percentile	16
Q1	32
median	32
Q3	64
95-th percentile	128
Maximum	256
Range	254
Interquartile range (IQR)	32

Descriptive statistics

Standard deviation	53.868626
Coefficient of variation (CV)	0.8365949
Kurtosis	4.0785335
Mean	64.390335
Median Absolute Deviation (MAD)	28
Skewness	1.9408603
Sum	51963
Variance	2901.8288
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
32	311	38.5%
64	224	27.8%
128	137	17.0%
256	33	4.1%
16	29	3.6%
4	25	3.1%
24	14	1.7%
25	9	1.1%
20	3	0.4%
12	3	0.4%
Other values (10)	19	2.4%

Value	Count	Frequency (%)
2	1	0.1%
3	3	0.4%
4	25	3.1%
8	3	0.4%
10	1	0.1%
12	3	0.4%
15	1	0.1%
16	29	3.6%
20	3	0.4%
22	1	0.1%

Value	Count	Frequency (%)
256	33	4.1%
128	137	17.0%
64	224	27.8%
56	2	0.2%
51	1	0.1%
40	3	0.4%
35	3	0.4%
32	311	38.5%
25	9	1.1%
24	14	1.7%

Mobile_Size
Real number (ℝ)

High correlation

Distinct	47
Distinct (%)	5.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.6206605

Minimum	2
Maximum	44
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.4 KiB

Quantile statistics

Minimum	2
5-th percentile	4.5
Q1	4.5
median	4.77
Q3	6.3
95-th percentile	6.67
Maximum	44
Range	42
Interquartile range (IQR)	1.8

Descriptive statistics

Standard deviation	3.9574086
Coefficient of variation (CV)	0.70408248
Kurtosis	85.457977
Mean	5.6206605
Median Absolute Deviation (MAD)	0.27
Skewness	9.058579
Sum	4535.873
Variance	15.661083
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
4.5	182	22.6%
4.54	139	17.2%
4.77	56	6.9%
6.5	37	4.6%
6.7	28	3.5%
6.4	24	3.0%
6.2	23	2.9%
5.5	19	2.4%
6.44	18	2.2%
6.39	18	2.2%
Other values (37)	263	32.6%

Value	Count	Frequency (%)
2	8	1.0%
3.7	15	1.9%
4.4	17	2.1%
4.5	182	22.6%
4.503	1	0.1%
4.52	3	0.4%
4.54	139	17.2%
4.57	2	0.2%
4.58	13	1.6%
4.7	18	2.2%

Value	Count	Frequency (%)
44	8	1.0%
7	2	0.2%
6.7	28	3.5%
6.67	13	1.6%
6.6	4	0.5%
6.59	4	0.5%
6.55	4	0.5%
6.53	11	1.4%
6.52	2	0.2%
6.5	37	4.6%

Primary_Cam
Real number (ℝ)

Distinct	11
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	47.821561

Minimum	5
Maximum	64
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.4 KiB

Quantile statistics

Minimum	5
5-th percentile	35
Q1	48
median	48
Q3	48
95-th percentile	64
Maximum	64
Range	59
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	11.155916
Coefficient of variation (CV)	0.23328215
Kurtosis	1.5820465
Mean	47.821561
Median Absolute Deviation (MAD)	0
Skewness	-0.63585453
Sum	38592
Variance	124.45447
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
48	446	55.3%
64	171	21.2%
35	79	9.8%
38	71	8.8%
25	11	1.4%
8	9	1.1%
16	6	0.7%
20	5	0.6%
26	4	0.5%
40	3	0.4%

Value	Count	Frequency (%)
5	2	0.2%
8	9	1.1%
16	6	0.7%
20	5	0.6%
25	11	1.4%
26	4	0.5%
35	79	9.8%
38	71	8.8%
40	3	0.4%
48	446	55.3%

Value	Count	Frequency (%)
64	171	21.2%
48	446	55.3%
40	3	0.4%
38	71	8.8%
35	79	9.8%
26	4	0.5%
25	11	1.4%
20	5	0.6%
16	6	0.7%
8	9	1.1%

Selfi_Cam
Real number (ℝ)

Distinct	21
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.8686493

Minimum	0
Maximum	23
Zeros	5
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	6.4 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	8
median	8
Q3	12
95-th percentile	20
Maximum	23
Range	23
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	4.5472535
Coefficient of variation (CV)	0.51273349
Kurtosis	0.95534988
Mean	8.8686493
Median Absolute Deviation (MAD)	3
Skewness	0.79226801
Sum	7157
Variance	20.677515
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
8	374	46.3%
5	100	12.4%
12	78	9.7%
13	64	7.9%
2	60	7.4%
20	31	3.8%
1	21	2.6%
15	20	2.5%
16	9	1.1%
11	8	1.0%
Other values (11)	42	5.2%

Value	Count	Frequency (%)
0	5	0.6%
1	21	2.6%
2	60	7.4%
4	1	0.1%
5	100	12.4%
6	1	0.1%
7	5	0.6%
8	374	46.3%
10	2	0.2%
11	8	1.0%

Value	Count	Frequency (%)
23	6	0.7%
22	7	0.9%
21	2	0.2%
20	31	3.8%
18	5	0.6%
17	1	0.1%
16	9	1.1%
15	20	2.5%
14	7	0.9%
13	64	7.9%

Battery_Power
Real number (ℝ)

High correlation

Distinct	49
Distinct (%)	6.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3278.86

Minimum	1020
Maximum	6000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.4 KiB

Quantile statistics

Minimum	1020
5-th percentile	1200
Q1	3000
median	3000
Q3	3800
95-th percentile	4780
Maximum	6000
Range	4980
Interquartile range (IQR)	800

Descriptive statistics

Standard deviation	937.6288
Coefficient of variation (CV)	0.28596183
Kurtosis	0.52935522
Mean	3278.86
Median Absolute Deviation (MAD)	500
Skewness	-0.24451162
Sum	2646040
Variance	879147.77
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
3000	262	32.5%
3500	111	13.8%
3800	98	12.1%
4700	48	5.9%
2500	37	4.6%
5000	33	4.1%
1750	28	3.5%
1050	19	2.4%
2800	19	2.4%
1200	17	2.1%
Other values (39)	135	16.7%

Value	Count	Frequency (%)
1020	4	0.5%
1050	19	2.4%
1080	4	0.5%
1100	1	0.1%
1200	17	2.1%
1500	3	0.4%
1550	7	0.9%
1750	28	3.5%
1900	4	0.5%
2000	7	0.9%

Value	Count	Frequency (%)
6000	6	0.7%
5000	33	4.1%
4900	1	0.1%
4780	2	0.2%
4700	48	5.9%
4600	1	0.1%
4550	1	0.1%
4440	8	1.0%
4300	1	0.1%
4230	11	1.4%

Price
Real number (ℝ)

High correlation

Distinct	241
Distinct (%)	29.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14269.167

Minimum	479
Maximum	153000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.4 KiB

Quantile statistics

Minimum	479
5-th percentile	649
Q1	984
median	1699
Q3	18994.5
95-th percentile	53990
Maximum	153000
Range	152521
Interquartile range (IQR)	18010.5

Descriptive statistics

Standard deviation	23092.74
Coefficient of variation (CV)	1.6183663
Kurtosis	10.796041
Mean	14269.167
Median Absolute Deviation (MAD)	1060
Skewness	2.9527044
Sum	11515218
Variance	5.3327464 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
649	30	3.7%
799	18	2.2%
1199	18	2.2%
1099	17	2.1%
1299	15	1.9%
24999	14	1.7%
1349	14	1.7%
599	12	1.5%
18999	11	1.4%
749	10	1.2%
Other values (231)	648	80.3%

Value	Count	Frequency (%)
479	1	0.1%
539	1	0.1%
559	1	0.1%
595	1	0.1%
599	12	1.5%
629	6	0.7%
639	10	1.2%
645	1	0.1%
649	30	3.7%
650	2	0.2%

Value	Count	Frequency (%)
153000	1	0.1%
140300	5	0.6%
121300	2	0.2%
117100	6	0.7%
112450	1	0.1%
106600	2	0.2%
103000	1	0.1%
84900	1	0.1%
77999	6	0.7%
75000	1	0.1%

	Battery_Power	Mobile_Size	Price	Primary_Cam	RAM	ROM	Ratings	Selfi_Cam
Battery_Power	1.000	0.598	0.560	-0.113	0.054	0.450	0.515	-0.088
Mobile_Size	0.598	1.000	0.796	-0.271	0.121	0.578	0.626	-0.184
Price	0.560	0.796	1.000	-0.291	0.144	0.538	0.710	-0.077
Primary_Cam	-0.113	-0.271	-0.291	1.000	0.137	-0.133	-0.216	0.179
RAM	0.054	0.121	0.144	0.137	1.000	0.389	0.158	0.238
ROM	0.450	0.578	0.538	-0.133	0.389	1.000	0.420	-0.017
Ratings	0.515	0.626	0.710	-0.216	0.158	0.420	1.000	-0.051
Selfi_Cam	-0.088	-0.184	-0.077	0.179	0.238	-0.017	-0.051	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	Ratings	RAM	ROM	Mobile_Size	Primary_Cam	Selfi_Cam	Battery_Power	Price
0	4.3	4.0	128.0	6.00	48	13.0	4000	24999
1	3.4	6.0	64.0	4.50	48	12.0	4000	15999
2	4.3	4.0	4.0	4.50	64	16.0	4000	15000
3	4.4	6.0	64.0	6.40	48	15.0	3800	18999
4	4.5	6.0	128.0	6.18	35	15.0	3800	18999
5	4.7	8.0	128.0	5.80	35	12.0	5000	140300
6	4.4	8.0	128.0	6.70	64	5.0	4700	29999
7	4.5	8.0	128.0	6.70	48	12.0	4700	47999
8	4.4	4.0	128.0	6.53	48	2.0	4020	16490
9	4.5	8.0	256.0	6.18	35	5.0	3800	22999

	Ratings	RAM	ROM	Mobile_Size	Primary_Cam	Selfi_Cam	Battery_Power	Price
797	3.5	6.0	32.0	4.52	48	8.0	3500	2599
798	4.7	8.0	64.0	6.50	35	12.0	3500	117100
799	4.6	4.0	64.0	6.20	35	8.0	3500	53990
800	4.4	6.0	128.0	6.39	48	12.0	3800	31999
801	3.6	6.0	32.0	4.50	48	8.0	3000	898
802	3.8	6.0	32.0	4.54	48	12.0	2800	1299
803	4.1	8.0	64.0	4.54	64	8.0	2500	1390
804	4.4	3.0	32.0	6.20	48	1.0	3800	9790
805	3.7	10.0	32.0	4.50	64	8.0	3500	799
806	3.5	6.0	32.0	4.50	64	15.0	1050	799

Most frequently occurring

	Ratings	RAM	ROM	Mobile_Size	Primary_Cam	Selfi_Cam	Battery_Power	Price	# duplicates
129	4.5	6.0	128.0	6.39	48	13.0	3800	24999	7
138	4.5	8.0	128.0	6.70	48	12.0	4700	47999	7
121	4.5	6.0	32.0	4.50	64	8.0	3000	649	6
139	4.5	8.0	128.0	6.70	64	1.0	4700	77999	6
103	4.4	6.0	64.0	6.40	48	5.0	3800	18999	5
140	4.5	8.0	256.0	6.18	35	5.0	3800	22999	5
146	4.6	4.0	64.0	6.20	35	8.0	3500	53990	5
154	4.7	8.0	64.0	6.50	35	12.0	3500	117100	5
2	3.4	4.0	64.0	5.50	48	5.0	3000	13999	4
11	3.6	6.0	32.0	4.50	48	8.0	3000	898	4

Overview

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring

Overview

Variables

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring